import numpy as np
import pandas as pd
# import matplotlib.pyplot as plt
df1 = pd.read_excel('SalesData处理版地区.xlsx')
df2 = pd.read_excel('SalesData处理版国家.xlsx')
df3 = df1.groupby(['地区']).sum()
a = df3.index
df3['地区'] = a
df3.to_excel('task1_1.xlsx', index=False)
df4 = df2.groupby(['国家']).sum()
b = df4.index
df4['国家'] = b
df4.to_excel('task1_2.xlsx', index=False)
